EMT Practice Test

1. Question Content...

---

Question1: Northern Trail Outfitters (NTO) wants to find ways to better drive return on investment and growth via their marketing sends. They plan to centralize their analytics data to allow for a more efficient analysis of this data across all of their campaigns. NTO currently has Marketing Cloud, Sales Cloud, and a third-party warehouse service.
What product would help their use case?

Question2: A daily deal website is concerned with their sender reputation and needs consistent visibility into subscribers who report their email as spam.
How can they determine which subscribers reported their email as spam so they can flag those records in their customer service database?

Question3: Northern Trail Outfitters is using a Salesforce entry event in a Journey to send SMS to contacts located in the United States. They notice new SMS contacts are not receiving messages, and the mobile number in the Salesforce Entry Data Extension was missing the country code.
How could they resolve this issue?

Question4: Northern Trail Outfitters (NTO) plans to use Contact Builder to increase the scope of customer information they can see in an effort to establish more effective 1:1 relationships. NTO has a separate instance of Salesforce Sales Cloud that serves as their current customer master database.
What action should be taken when using Contact Builder? Choose 2 answers

Question5: A customer wants to integrate a new dataset with pre-existing contacts. This data will be updated via separate data feeds from the main contact information.
What data model configuration should be recommended'

Question6: Northern Trail Outfitters is using Journey Builder to send emails to loyalty members based on recent activity. They anticipate that approximately half of their contacts will meet the entry criteria for their journey.
How should they configure their entry source?

Question7: Northern Trail Outfitters has a customer login page on their website and wants to use Marketing Cloud to send an email to customers who need to reset their password. The email needs to be sent as quickly as possible. Their web server should receive a notification when the email is sent.
Which solution should they use?

Question8: Northern Trail Outfitters has several business units (BU) and each BU uses specific data extensions, like Product Information.
How Should they configure these data sources?

Question9: Northern Trail Outfitters wants to query Marketing Cloud for send data across SMS, Push, and email.
What would a consultant recommend?

Question10: Northern Trail Outfitters wants to send an email to website visitors who add items to their cart but fail to make a purchase. The email will include a list of products they added to their shopping cart.
* A sendable data extension contains the contact information and a session ID field for each subscriber who has abandoned their cart.
* A second data extension contains a corresponding session ID field and product data for each abandoned cart item, including product SKU, product name, quantity, price, and image URL.
Which feature should be used to display the list of products for each subscriber in this email?

Question11: A customer plans to configure multiple business units (BU) to support the digital marketing efforts of five international offices.
Which reasons warrants this implementation? Choose 2 answers.

Question12: Northern Trail Outfitters has been using Marketing Cloud for one of their brands for the last year and wants to migrate another brand to their portfolio. The two brands have contrasting target groups and identities so they need the emails and landing pages to have different styles that refrain from mentioning the other brand in any way.
What should be recommended?

Question13: A customer wants to link web analytics data to subscriber data.
How should this be set up in Data Designer?

Question14: A customer would like to send a quarterly re-engagement email to subscribers who have not opened in the previous three months. The customer's plans are to:
* Use an existing Paste HTML email for the first send.
* Make only minor changes to the email creative for future sends.
* Use an existing Measure to build the subscriber audience for current and future sends.
* Deploy emails manually for now, but possibly automate in the future.
Which configuration is recommended for the re-engagement email send?

Question15: Northern Trail Outfitters (NTO) is launching a new campaign, driving it to redesign its data structure. NTO needs to change the cardinality between two data extensions inside Contact Builder.
What are two consequences of this change? Choose 2 answers

Question16: Northern Trail Outfitters sends a monthly loyalty balance email to inform members of their current points balance. Emails are segmented based on loyalty status, and no segment should contain more than 2500 contacts for any send.
What should be used to prevent emails from being sent if they exceed 2500 contacts7

Question17: A small restaurant franchise wants to implement Marketing Cloud to support their franchise owners. The corporate office the advertising copy and subscriber list. The owners of franchised stores add a customized local message to the marketing campaign.
What hierarchy should be recommended?

Question18: Northern Trail Outfitters is noticing a gradual decline in the percentage of conversions per emails sent in their digital marketing campaign. A new initiative is being adopted to reverse the trend
What action should be taken to increase subscriber engagement?
Choose 2 answers

Question19: Northern Trail Outfitters injects customers into journey B based upon email engagement in journey A.
Which method would facilitate this solution?

Question20: A real estate agency wants to send out a biweekly newsletter with the list of properties for all new contacts added to a newsletter campaign in their Salesforce CRM. The journey consists of an initial message with property listings and a follow up to those who have engaged with the content.
The rules around which properties are matched to the contact depend on agent assigned as a contact owner, other agents who might have interacted with the contact, and contact's property interest. The data model has a relationship between contact > person account > real estate agent > property objects and all of those are available in CRM as well as synchronized to Marketing Cloud.
What solution should be recommended for execution efficiency?

Question21: Which two statements are correct about Send Logging? Choose 2 answers

Question22: Northern Trail Outfitters (NTO) wants to better understand subscriber behavior on their website upon arrival via an email message. A local member of a Marketing Cloud user group mentioned the Web Analytics Connector.
Which benefit is offered by installing the Web Analytics Connector in a Marketing Cloud account?
Choose 3 answers

Question23: Northern Trail Outfitters wants to import new contacts gathered from an external web form. The entries are being collected at high frequency, potentially thousands per minutes. The data does not need to be immediately ingested into Marketing Cloud as it is used in a daily scheduled automation.
What Should be recommended?

Question24: Northern Trail Outfitters' account is configured with Multi-Org to leverage two Salesforce CRM accounts. In the Cloud Kicks business unit they want to disconnect the sandbox instance and connect the production instance.
What additional configuration changes should they make?

Question25: A customer wants to send a quarterly reengagement email to subscribers who have NOT opened in the previous three months. The customer's plans are to:
* Use an existing Paste HTML email for the first send.
* Make only minor changes to the email creative for future sends.
* Send to the subscriber list.
* Deploy emails manually for now, but possibly automate in the future.
Which send method should be used?

Question26: Northern Trail Outfitters (NTO):
* Employs Email Specialists responsible for creating content, testing, sending emails, defining the activities for Automation Studio, and creating automations.
* Prefers not to use custom roles unless it is absolutely necessary.
* Email Specialist resides in multiple business units.
Using best practices, how should a consultant create and assign roles for NTO?

Question27: What are the similarities between Automation Studio and Journey Builder?

Question28: Northern Trail Outfitters is sending email messages using Marketing Cloud Connect through the Sales Cloud user interface. All of their sends initiated from Sales Cloud have a status of failed.
What should the consultant do to diagnose the issue?

Question29: A customer is interested in designing a solution to ensure that subscribers only receive categories of emails that they want to receive. The built-in subscription center will beused as part of the solution.
Which feature should be utilised to make this happen?

Question30: Northern Trail Outfitters and its subsidiaries use Sales Cloud and Marketing Cloud to send customers frequest email communications of new products and updates on their portfolios. They have noticed the messages and branding being sent varies greatly and would like to create a bether customer experience.
What extension product should be considered to unify the messaging and branding of these communications while still allowing personalization and timing of campaigns?

Question31: Northern Trail Outfitters (NTO) needs to provide an IT staff member with access to Marketing Cloud. The staff member needs to perform the following tasks:
* Maintain NTO's master suppression list
* Configure data relationships
* Create new subscriber attributes
Which role should be assigned to the IT staff member?

Question32: Northern Trail Outfitters wants to automate a weekly SMS message to be sent to anyone who has a birthday that week. They have created the Outbound Message in MobileConnect and have a Filtered List created for every contact who provided birth date information.
Which activities would Marketing Cloud use to automate this campaign?

Question33: Northern Trail Outfitters wants to set up an automation that imports a file and sends an email to the contacts when the file is dropped on the SFTP. The name of the file will change, though it will always start with thankyou_customers.
How would they set up the Import Activity to know the name of the file?

Question34: A consulting has a data extension that contains all current product information. The customer wants to refresh data each morning by importing a CSV containing today's product catalog. The product catalog is never the same; products can be added and removed.
Which import type should be used?

Question35: When joining a data extension in Contact Builder, in which scenario should a consultant mark the Use as Root checkbox?

Question36: Northern Trail Outfitters (NTO) is running a campaign for a brand new type of footwear inside Journey Builder. The entry event: Prevents contacts from entering the journey if "shoes" is not selected in their preferences.
Is based on a data extension which has Email Address as Primary Key.
A few weeks after launching the campaign, NTO's data analyst noticed a reduced email volume and that some contacts inside the data extension updated their preferences after the launch of the campaign. Even with
the entry event being triggered every day, those contacts are not receiving the welcome emails.
What could be the reason?

Question37: A customer is starting a new children's fashion brand and wants to use a dedicated business unit within their existing Enterprise 2.0 account. They anticipate many of their current Enterprise contacts will subscribe to the children's brand, however, they want to separate subscriber opt-outs of the Enterprise and children's brands. The customer has minimal technical resources available for implementation and support.
What should a consultant recommend to meet these criteria?

Question38: Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeros, but they will NOT be included in the final values.
Which data type should they use for the Order ID field?

Question39: Northern Trail Outfitters is noticing a gradualdecline in the percentage of conversions per emails sent in their digital marketing campaign. A new initiative is being adopted to reverse the trend.
What action should be taken to increase subscriber engagement? Choose 2 answers

Question40: NTO has to import a file that will be different every time.
What method should be used?

Question41: A customer wants to set up a real-time, API-driven way to be alerted when transactional messages fail to send out of Marketing Cloud. They are currently in the process of hiring a full-time developer but want an implementation in place for the developer to maintain.
What should the customer have in place to ensure this solution can be implemented?

Question42: An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and NotSent, to ensure they are fulfilling a legal object due to the nature of their messages.
What method should be suggested in this scenario?

Question43: A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:
* CustomerlD
* FirstName
* EmailAddress
* OrderlD
* OrderDate
* ShippedDate
Which SQL statement should the consultant use?

Question44: A customer team wants to retarget subscribers who click on links of key items promoted across email campaigns. The customer has indicated the following:
* Emails will be built using a custom dynamic template for these messages.
* Links will vary over time and across campaigns.
* Click activity will be cross-referenced with subscribers' regional markets on a master subscriber data extension.
* Retargeting messages will dynamically populate content based on regional market.
In order for this solution to be viable, which skill set does the customer team need to possess?

Question45: A customer manages their field technicians in Salesforce CRM connected to Marketing Cloud. Once an appointment with a contact is scheduled for the technician through CRM, the notification message should be sent to the contact informing them about the scheduled visit date. When the notification is sent the "Confirmation sent" checkbox on the appointment record should be updated in CRM.
All appointments scheduled on a given day will have their status updated in CRM at the end of business hours. The Appointment object does not have a direct relationship with the contact.
What solution would a consultant recommend to address this use case?

Question46: The customer has the following requirements for storing engagement data in their data warehouse:
* All email open and click activity must be pulled daily from MC
* Output files must meet the specific requirements for the data warehouse
* All the activity must be provided via FTP in one file.
Which automation workflow meets the customer requirements?

Question47: An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and NotSent, to ensure they are fulfilling a legal obligation due to the nature of their messages.
What method should be suggested in this scenario?

Question48: An online retail customer needs daily promotional email content to generate with minimal time spent on creation. Their service contract includes building a custom dynamic template for this purpose. The customer has communicated the following:
* The email content will highlight new inventory each day.
* A small team will run both their digital marketing operations and their email program.
* A user needs to build, test, and send a daily email in less than an hour.
* Images for the emails will be hosted on their website CMS.
Which question is relevant to identify strategies for designing the custom template for the customer's daily promotional email? Choose 3 answers

Question49: Customer Event:
* gather data through a tablet-based webform as part of a raffle into a data extension.
* Winner is randomly selected.
* After the event, an email should be sent to the participants to gather opt ins for marketing emails.
Define 2 things necessary:

Question50: Northern Trail Outfitters (NTO) is creating a birthday journey and one of the requirements is to divert anyone who has redeemed the promotional code before reminder emails are sent on the 15th and 20th of each month. Their transactional information, which includes redeemed promo codes, Is housed in a separate data extension than the one used for Journey injection. NTO needs to use an attribute to attribute comparison on the customer number field in the Journey source and transaction data extensions.
Which activity would they use to accomplish this?

Question51: Northern Trail Outfitters (NTO) wants to import recent customer transaction data from their data warehouse into Marketing Cloud on a nightly basis. They plan to create a File Drop Automation to trigger an automation when a data file is transferred from the data warehouse to the import folder in their Enhanced FTP account. NTO notes that user passwords expire every 90 days and they do not want to update their file transfer script on the data warehouse each time a password changes and they do not want to compromise security.
Which solution should the consultant recommend?

Question52: A customer has several values that need to be used in the body of an email send.
* The data would be stored in a reference data extension, related on SubscriberKey
* There may be one or more records for each subscriber
* The audience is generally over 1 million subscribers
* The content is time sensitive and should be sent as quickly as possible
* The customer is not using "Catch and release" sending
* The reference data extension contains 25 columns
What method should be used

Question53: A customer asks why the send time values within an email are not being added to a Send Log.
Which two actions would successfully write send time variables to their Send Log? Choose 2 answers

Question54: Northern Trail Outfitters upgraded their Marketing Cloud account which now includes a Sender Authentication Package (SAP), They send regularly 300,000
What should they be aware of with respect to sender reputation?

Question55: Tracking Alias question:

Question56: What are two possible outcomes when "Multipart MIME" is selectedduring the send process? Choose 2 answers

Question57: A large retail group consists of a corporate team and several divisions operating under different brand names. All plan to share one Marketing Cloud account. Each brand has its own marketing department and operates independently, with its own creative assets, subscribers, and data structure.
What are the two reasons why the recommended account configuration is one corporate Parent account, with each brand configured as a separate child Business Unit? Choose 2 answers

Question58: A customer wants to automate the process of sending a series of welcome emails based on the Subscriber's dat
a. Emails should be sent weekly for up to five weeks. If a subscriber makes a purchase, they should stop receiving welcome emails. A Boolean flag should be set in the data extension if the subscriber makes it through the welcome series.
Which steps should be used to accomplish this in Journey Builder?

Question59: A company is hosting a series of events and wants its customers who register to enter into a journey.
Which two methods are viable configurations for entry? Choose 2 answers

Question60: Northern Trail Outfitters (NTO) wants to use Marketing Cloud to solicit customer service feedback. If a customer indicates they are unhappy with the service they have received, NTO wants a new case to be created in Service Cloud. NTO is unsure of what is possible within Marketing Cloud but would like to use as much native functionality as possible.
What approach would a consultant recommend?

Question61: Northern Trail Outfitters is interested in a solution to automate a process. They currently pull data into a spreadsheet to import into a data extension for sending. The data warehouse can be configured to place a dally on an SFTP.
Which three questions are relevant to determining a solution?
Choose 3 answers

Question62: A company collects subscriptions on its websites. It does the following:
* Compiles that subscription list in a database in the website content Management System (CMS).
* Posts this encrypted list to Marketing Cloud nightly at 11 p.m.
* Uses Marketing Cloud as the database of record.
* Sends up to five emails a week based on subscriber engagement with prior sends.
What automation sequence (excluding waits) should cover these requirements?

Question63: During discovery, the customer outlines data requirements and the anticipated use of Marketing Cloud with the following criteria:
* Customer data will be fully refreshed every night via Import activity from the customer's data warehouse.
* Contact records will be augmented by relational data tables via Contact Builder.
* The customer data file will contain 5M records with 40+ attributes.
* One attribute will house HTML code, 1000 characters max, that will be used to populate Account Access content areas in emails.
* A customer ID will be used as the unique identifier for each contact.
Which statement differentiates the use of data extensions over lists?

Question64: Collect addresses through Smartcapture, segment the data, send emails referencing data from a data extension.
What skillset is needed ?

Question65: A large retail company has selected Marketing Cloud and has asked to be fully migrated from their existing platform in three weeks. They have communicated the following:
* They currently have 3 million customers.
* They email customers twice a week with no known deliverability issues.
* Their contract includes one Sender Authentication Package (SAP).
What response articulates proper IP warming?
Choose 2 answers

Question66: As part of their brand guidelines, Northern Trail Outfitters (NTO) uses a custom brand font for all print marketing materials. NTO wants to use their custom brand font in email as well.
What is the recommended best practice for font usage in email?

Question67: A customer wants to create a mobile app that requires users to log in or register before accessing their dat
a. Their source of truth is Sales Cloud which is connected to Marketing Cloud. Users who log in with existing credentials will have their device associated with their ContactKey. Users who register with the mobile app will not have their devices associated with a ContactKey for up to 24 hours.
What consideration should a consultant provide to the customer?

Question68: Northern Trail Outfitters (NTO) wants email subscribers to adopt their app. They are investigating using MobileConnect features since over 90% of their subscribers provide a Mobile Phone Number when registering.
Which three considerations should be made before implementing MobileConnect?
Choose 3 answers

Question69: A new Marketing Cloud (MC) customer wants to now implement a Sales Cloud instance to go along with their MC Instance. The MC instance has been live for a year now, where the primary key for records has been the Email Address.
Which two options would prevent the customer from duplicating records? (Choose 2 answers)

Question70: A bank wants to send out a series of emails to new customers that open a checking or savings account. The emails will be used to educate and inform customers regarding their current account and other bank offerings
* Data for the campaign will be in two data extensions: Customer and New Accounts
* The Customer data extension is currently used for multiple campaigns and is updated at 1:00 a.m.
* The New Accounts data is encrypted and will be placed on the FTP at 10:00 p.m.
Which automated workflow meets the customer's requirements?

Question71: what storage model should be used if a subscriber has more than one value for an attribute?

Question72: A customer needs to compare the engagement across three creative versions, and then send a follow-up email for those contacts who did not engage with any of the test versions.
Which sequence of activities would best accomplish this?

Question73: The Corporate Apparel Division of Northern Trail Outfitters (NTO) is moving to Marketing Cloud and will be using NTO's existing account. The Corporate Apparel team has asked for a recommendation on whether they should have a separate Business Unit.
Which consideration warrants the creation of a separate Business Unit for Corporate Apparel's instance of Marketing Cloud?

Question74: By which three standard methods could contacts be injected into a journey? Choose 3 answers

Question75: Northern Trail Outfitters continually adds rows for subscribers to a data extension via API, populating subscribers who should receive a monthly payment reminder that day. They want to use Journey Builder to send the payment reminder emails.
What would be required to process the correct subscribers?

Question76: Northern Trail Outfitters (NTO) wants its monthly distributor newsletter email to appear to be sent on behalf of the subscriber's account representative without segmenting the audience by sales representative.
In which two ways could this distributor-specific sender profile be configured in a Marketing Cloud account with Sender Authentication Package implemented?
Choose 2 answers

Question77: Northern Trail outfitters needs to reduce the amount of work when managing messages to customers, but cannot add any more personnel due to budget constraints. There has been an increased number of customer purchases on their website, and the team currently sends batch order confirmations.
What solution will decrease manual workloads on the team and will improve their customers' experience?

Question78: A publishing company has presented the following:
* A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days.
* A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical.
* The customer's expiration date is included in the data file.
What component should the customer's solution include?
Choose 3 answers

Question79: A customer has several values that need to be used in the body of an email send:
* The data would be stored in a reference data extension, related on SubscriberKey.
* There may be one or more records for each subscriber.
* The audience is generally over 1 million subscribers.
* The content is time sensitive and should be sent as quickly as possible.
* The customer is not using "catch and release" sending.
* The reference data extension contains 25 columns.
Which method should be used?

Question80: Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE).
* The first DE is populated by web analytics data, and does not contain a Subscriber Key or Email Address value.
* A Customer Reference DE is updated daily and holds subscriber information.
* The third DE is populated by a file sent to the SFTP after five days If the customer has not purchased the abandoned items.
* The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address.
* If the web analytics file is empty, NTO does not want the automation to finish running.
Which order of activities should be used to fulfill this requirement?

Question81: Northern Trail Outfitters recently purchased Marketing Cloud to start running cross-channel campaigns. They are looking for guidance on which value to use as the subscriber key.
Which two options should the consultant recommend? (Choose 2 answers)

Question82: Northern Trail Outfitters (NTO) imports a file daily into Marketing Cloud of customers who have bought a tent from their website that day. They want to set up a month-long welcome Journey which sends emails specific to the purchase such as the type of tent, the available accessories for the tent, and care of the tent at different points throughout the Journey. NTO also recognizes that due to their competitive prices, they have had customers purchase more than one tent within a month.
What type of data should be used in the Decision Splits in their Journey to make sure the choices reflect the correct tent?

Question83: A customer needs to import data from an SFTP site. The customer wants to:
* Segment the contents of the file and then send emails.
* Transfer the file to the SFTP site at various times daily.
* Send to data extensions.
Which workflow should meet these requirements?

Question84: Northern Trail Outfitters has a file that drops intermittently to their SFTP account. Once this file drops, they want to be able to have it immediately imported and then segmented to enter a specific journey depending on the data inside the file.
Which two options would meet these requirements?
Choose 2 answers

Question85: Northern Trail Outfitters sends emails for Password Resets from their web store when requested. An SMS message should be deployed if the password reset email is not sent.
What processes should they utilize to ensure a timely delivery across email and SMS?

Question86: Which two statements about a database of record are correct?
Choose 2 answers:

Question87: An existing triggered send needs to be updated with new content
Select the correct sequence

Question88: A customer notices their open and click rates are very low.
Which two aspects of list hygiene should be recommended to improve engagement rates? (Choose 2 answers)

Question89: A start-up meal delivery company recently launched in Canada to great success. Customers can orderindividual meal kits for up to six people or subscribe to a weekly meal kit delivery. As a new company, resources are limited, but demand is taxing their manual processes for sending out eCommerce messages, such as order confirmation and subscription confirmations.
What recommendation would provide a scalable solution for the start-up?

Question90: To fuel their expansion, Northern Trail Outfitters (NTO) recently acquired Eagle Outfitters (EO). There is currently a 30 percent overlap between the guests of each brand and they will be pursuing cross-marketing opportunities. It was recommended that their Marketing Cloud account now include a separate business unit for EO and the company secure a new senderauthentication package for EO using the private domain e-EO.com.
Select the statement that correctly describes the implication of this recommendation.
Choose 2 answers

Question91: A consultant explains how a sending domain differs from a customer's primary domain. The customer is evaluating their options around configuring their domain.
Which two questions should their IT team be asked?
Choose 2 answers

Question92: A customer wants to perform an email send to a subset of Synchronized Data Extension referencing Sales Cloud custom object data and return tracking to Sales Cloud.
Which two approaches should the consultant recommend?
Choose 2 answers

Question93: Northern Trail Outfitters uses a Salesforce Data Entry Source in their Journey that injects Salesforce Orders when they are either created or updated with a status of New, Currently Knitting Shipped, and Complete. Their Journey works when orders are created, but they notice that it does not inject customers when their status is updated.
What could be causing this?

Question94: Northern Trail Outfitters is sending to an audience of over one million subscribers. They will use 10 different personalized fields in the email which reside in multiple data extensions. The goal is a timely email send from start to finish as it contains a limited quantity, first come-first served, special offer.
How should they accomplish this task?

Question95: A customer is connecting Sales Cloud with Marketing Cloud. The connection was successful, however, the team is unable to view or sync Sales Cloud objects in Contact Builder.
How should a consultant begin troubleshooting the connection?

Question96: When more than one subscriber email address field is created within Contact Builder, what action tells the platform which email address to prioritize in the Email application?

Question97: A Marketing Cloud user needs the email addresses of everyone who unsubscribed from a particular email send. This user does NOT know SQL and does NOT have access to the Enhanced FTP account.
What functionality should be used to retrieve the necessary data?

Question98: ABC Company wants to automate the sending of shipping notices and a customer survey.
* Shipping notices will be sent once a day.
* The shipping file will be placed on the FTP some time after 4:00 p.m.
* The shipping data will be sorted in the Shipping Notice data extension.
* A field in the data extension will contain the shipping date.
* The survey needs to be sent at 9:00 a.m., exactly 10 days after the customer's order ships.
Which workflow would most effectively enable ABC Company to do this?

Question99: A customer will provide a single daily file on the Marketing Cloud SFTP at 3 AM and needs an alert if the file is not present on time. The file needs to be: Imported into a staging data extension. Separated into two different
data extensions.
Which workflow should meet these requirements?

Question100: A consultant is configuring Marketing Cloud Connect in Marketing Cloud. The customer requires that integrated users only have access to Sales Cloud data visible to them in their Salesforce account.
How would the consultant ensure that this requirement is met?

Question101: Northern Trail Outfitters (NTO) is migrating from a series of local legacy email automation tools to a single global Marketing Cloud instance to leverage its multi-channels abilities as well as native Salesforce Connector to their global Sales Cloud instance.
Which three factors Should be considered before finalizing the number of business unit they need to purchase? (Choose 3 answers)

Question102: A customer team wants to retarget subscribers who click on links of key items promoted across email campaigns. Click activity will be cross-referenced with subscribers' regional markets on a master subscriber data extension.
What skill set should the customer team have for this solution to be viable?